Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# SESSION_MAX_OPEN_FILES

Property | Description
--- | ---
Parameter type | Integer
Default value | `10`
Modifiable | No
Range of values | 1 to either 50 or the value of `MAX_OPEN_FILES` defined at the operating system level, whichever is less

`SESSION_MAX_OPEN_FILES` specifies the maximum number of BFILEs that can be opened in any session. Once this number is reached, subsequent attempts to open more files in the session by using `DBMS_LOB.FILEOPEN()` or `OCILobFileOpen()` will fail. The maximum value for this parameter depends on the equivalent parameter defined for the underlying operating system.

See Also: Oracle Database Application Developer's Guide - Large Objects for information on LOBs in general and BFILEs in particular Oracle Database PL/SQL Packages and Types Reference for information on the `DBMS_LOB.FILEOPEN()` procedure Oracle Call Interface Programmer's Guide for information on the `OCILobFileOpen()` procedure